package com.example.wxminiprogram.mapper;

import com.example.wxminiprogram.pojo.GoodsClass;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ClassMapper {
    @Select("select name from class_level2 where id = #{id}")
    String getL2NameById(Integer id);
    @Select("select * from class_level1")
    List<GoodsClass> getL1();
    @Select("select * from class_level2")
    List<GoodsClass> getL2();
    @Select("select * from class_level2 where super_id = #{super_id}")
    List<GoodsClass> getL2BySuperId(Integer super_id);
}
